﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using SQLExecute;

/// <summary>
/// Summary description for Working_Experience
/// </summary>
public class Working_Experience:Profiles
{

    public string _employer1, _employer2, _employer3;
    public int _salary1, _salary2, _salary3;
    public string _pos1, _pos2, _pos3;
    public string _supervisor1, _supervisor2, _supervisor3;

    public string Employer1
    {
        set { _employer1 = value; }
        get { return _employer1; }
    }
    public string Employer2
    {
        set { _employer2 = value; }
        get { return _employer2; }
    }
    public string Employer3
    {
        set { _employer3 = value; }
        get { return _employer3; }
    }
    


    public string Pos1
    {
        set { _pos1 = value; }
        get { return _pos1; }
    }
    public string Pos2
    {
        set { _pos2 = value; }
        get { return _pos2; }
    }
    public string Pos3
    {
        set { _pos3 = value; }
        get { return _pos3; }
    }
  


    public int Salary1
    {
        set { _salary1 = value; }
        get { return _salary1; }
    }
    public int Salary2
    {
        set { _salary2 = value; }
        get { return _salary2; }
    }
    public int Salary3
    {
        set { _salary3 = value; }
        get { return _salary3; }
    }
  

    public string Supervisor1
    {
        set { _supervisor1 = value; }
        get { return _supervisor1; }
    }
    public string Supervisor2
    {
        set { _supervisor2 = value; }
        get { return _supervisor2; }
    }
    public string Supervisor3
    {
        set { _supervisor3 = value; }
        get { return _supervisor3; }
    }
  


    private string _type_sal;

    public string TypeSalary
    {
        set { _type_sal = value; }
        get { return _type_sal; }
    }
	public Working_Experience()
	{
		//
		// TODO: Add constructor logic here
		//
	}

    public void Insert_Working_Experience()
    {
        SqlHelper.ExecuteNonQuery(Common.strConnect, "Insert_Working_Experience", new object[]
                              {this._id,this._employer1,this._employer2,this._employer3
                              ,this._pos1,this._pos2,this._pos3
                              ,this._salary1,this._salary2,this._salary3
                              ,this._type_sal
                              ,this._supervisor1,this._supervisor2,this._supervisor3
                              });
    }
    public void Update_Working_Experience()
    {
        SqlHelper.ExecuteNonQuery(Common.strConnect, "Update_Working_Experience", new object[]
                              {this._id,this._employer1,this._employer2,this._employer3
                              ,this._pos1,this._pos2,this._pos3
                              ,this._salary1,this._salary2,this._salary3
                              ,this._type_sal
                              ,this._supervisor1,this._supervisor2,this._supervisor3
                              });
    }


}
